﻿
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sproc_Ext_AddFile]') AND type in (N'P', N'PC'))
    DROP PROCEDURE [dbo].[sproc_Ext_AddFile];
GO
CREATE PROCEDURE [dbo].[sproc_Ext_AddFile]
    @DocID int,
    @FileName nvarchar(255),
    @FileSize int,
    @FileAttribute int,
    @FileVisualPath nvarchar(255),
    @FileAuthor nvarchar(255),
    @FileCatlog nvarchar(255),
    @FileAddedDate datetime
    
AS
insert into uds_files (DOCID,[FILENAME],FILESIZE,FILEATTRIBUTE, FILEVISUALPATH,FILEAUTHOR,FILECATLOG,FILEADDEDDATE)
        values(@DocID,@FileName,@FileSize,@FileAttribute,@FileVisualPath,@FileAuthor,@FileCatlog,@FileAddedDate)